drop table jms_dm.dm_nosign_waybill_dt ;
create external table jms_dm.dm_nosign_waybill_dt (
   input_time                 date             comment '录入时间'
  ,waybill_no                 string           comment '运单编号'
  ,terminal_dispatch_code     string           comment '三段码'
  ,package_name               string           comment '集包地'
  ,receiver_name              string           comment '收件人姓名'
  ,receiver_mobile_phone      bigint           comment '收件人电话'
  ,receiver_address           string           comment '收件人地址(多字段concat)'
  ,sender_name                string           comment '寄件人姓名'
  ,sender_mobile_phone        bigint           comment '寄件人电话'
  ,sender_address             string           comment '寄件人地址(多字段concat)'
  ,remarks                    string           comment '备注'
  ,delivery_time              timestamp        comment '寄件时间'
  ,pre_3_receiver_mobile      string           comment '收件人电话前三位'
  ,pre_3_sender_mobile        string           comment '寄件人电话前三位'
  ,last_4_sender_mobile       string           comment '寄件人电话后四位'
  ,last_4_receiver_mobile     string           comment '收件人电话后四位'
)
    comment  '未签收运单明细表'
    partitioned by (dt string comment '时间分区')
    stored as parquet
    location '/dw/hive/jms_dm.db/external/dm_nosign_waybill_dt'
    tblproperties (
        'parquet.column.index.access' = 'true'
        );